﻿CREATE PROCEDURE [dbo].[sp_Get_CityByMdAndTerr]
	@mdnumber varchar(10), 
	@terr varchar(2)
AS
	select distinct City from dbo.ZipInfo 
	WHERE MdNumber = @mdnumber and Territory = @terr order by City